OpenCell Message

Syntax

on openCell [<row> [,<col>]]

end openCell Sent to an unlocked dataSheet

Description

The openCell message is generated whenever a cell of an unlocked dataSheet is opened for editing, either by clicking in the cell or by navigating to the cell using the tab, return, enter, or arrow keys. If the insertion point is already in the cell, this message is not sent. The two integer parameters sent are the <row> and <col> of the opened cell. The upper-left cell of a dataSheet has a <row> of 1 and a <col> of 1.

Notes

The openCell message does not apply to pickLists. When the mouse is clicked on the row or column labels of a dataSheet, the following parameters are sent with the mouseUp or mouseDown message: <0, col> (for column labels) and <row, 0> (for row labels). This message is sent only in Browse mode. _______________________________________ Examples: Add the following handler to a dataSheet: on openCell openRow, openCol select cell openRow, openCol of the target Copy end openCell Whenever the user clicks on an unlocked cell, the contents of the cell are automatically copied to the clipboard. The following handler instructs the user after she clicks in a cell: on openCell